Kelly P.
Kelly P.
Reactions
-
Re: Customize Calendar Display Column: select more than just the Primary Column
Another workaround would be to use the sheet's primary column to gather and format the text you'd like to see on the calendar. For example, with the formula below in the primary column, I pull the ta…1 · -
Re: June Question of the Month 💭 Join the conversation and receive a badge
Efficacious!2 · -
Re: Remove a character from cell and copy into "helper" column
@Bwoods113 Perhaps try the value function. =VALUE([Column Name]@row will change '2489 to 2489. Hope this helps!1 · -
Re: Search for specific words within texts
@Luiz Silva I'd probably put in a helper column with the formula below and then sum the values in that new column. =IF(CONTAINS("Day by day", [Column Name]@row), 1, 0) Hope this helps!2 · -
Re: I am trying to create a formula - If I Select "Yes" then multiply 25 by a specific cell.
@HNICHOLS Try this: =IF([Per Diem Eligible (Yes/No)]@row = "Yes", [# Nights]@row * 25, "") Hope that helps!1 ·
